Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TaxCertificateProgramID (PK) | A system assigned unique identifier fo a tax certificate program. | ID_TX_CF_PRGM | Identity | integer | |
TaxJurisdictionID (AK)(FK) | A unique system assigned identifier for the TaxJurisdiction. | ID_JRDT_TX | Identity | integer | TaxJurisdictionTaxType(RU_JRDT_TX_TYP_TX) |
TaxTypeCode (AK)(FK) | A retailer assigned mnemonic code denoting a kind of tax. Eg: SalesTax, GST, PST, HST, VAT | CD_TYP_TX | Code4 | char(4) | TaxJurisdictionTaxType(RU_JRDT_TX_TYP_TX) |
TaxCertificateProgramSequenceNumber (AK) | A sequential counter used to uniquely identify a tax program for a specific jurisdiction and tax type. | AI_TX_CF | LineNumber | smallint | |
TaxCertificateTypeCode (FK) | A code that describes a categorization of tax certificate types, such as exemption, zero rated, reverse charges, etc. | CD_TYP_TX_CF | TaxCertificateTypeCode | varchar(50) | TaxCertificateType(CO_TYP_TX_CF) |
MerchandiseHierarchyGroupID (FK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP | Identity | integer | MerchandiseHierarchyGroup(CO_MRHRC_GP) |
TaxCertificateProgramName | The name of the tax certificate program. | NM_TX_CF_PRGM | Name | varchar(40) | |
EffectiveDateTime | The effective date and time of this tax certificate program. | TS_EF | EffectiveDateTime | datetime | |
ExpirationDatetime | The expiration date and time of this tax certificate program. | TS_EP | ExpirationDateTime | datetime | |